UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WzAfpzmdgzYRLLheHODYapLTEI9GZT49COm3R9d8SlU='
WHERE
key_id = '3d77ac887801434263ad295d4b776b70605855a5ae5f241de5a0c60c9ec5bb61'
AND (
token = 'WzAfpzmdgzYRLLheHODYapLTEI9GZT49COm3R9d8SlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)