UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xYbsh3uL+56MUKNY+PJ9DxMDtEk+RKQLerrL/C9uSec='
WHERE
key_id = 'c2aaf4420d96840883606937d8cb977d339df1989c4c99de548ce2457934dc06'
AND (
token = 'xYbsh3uL+56MUKNY+PJ9DxMDtEk+RKQLerrL/C9uSec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)