UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tDco8Y1JA7y+bASmLRRJ3EiFZx8y6jqRA6+O5ooz9W0='
WHERE
key_id = 'cf09d63d4f3c80243ba18cd025f678bc3af99dce6555cc5cc697708abc443ebf'
AND (
token = 'tDco8Y1JA7y+bASmLRRJ3EiFZx8y6jqRA6+O5ooz9W0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)