UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ChKYm2zjUls2vgOb/n3MLk+dfSRl+FLVppVSD/5/6Zo='
WHERE
key_id = 'd40eb377063127a2e99da22aa32e75ca4a35deabd1a7035cbecb2ca6984ef9ec'
AND (
token = 'ChKYm2zjUls2vgOb/n3MLk+dfSRl+FLVppVSD/5/6Zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)