UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nPhwgb5uWoFryk2soM32Fl4IwvrjdIbEeESyMZRgh/A='
WHERE
key_id = 'c02afa71b89ad6ced2a61aad1907725380a10d65389792a0761ec407a56fa26b'
AND (
token = 'nPhwgb5uWoFryk2soM32Fl4IwvrjdIbEeESyMZRgh/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)