UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Noo33tsQ91bfzcmChJ9gv2Mwr5IeB5P/yGOk5nwQST4='
WHERE
key_id = '927298dd701fa02d681cbac0c498a667a326c712923e2ec591f28b7fc04c4f94'
AND (
token = 'Noo33tsQ91bfzcmChJ9gv2Mwr5IeB5P/yGOk5nwQST4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)