UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qfidCLMaJY2mqpAtxhYV85YJPez69GEenFvf6gLuVvo='
WHERE
key_id = 'a0ea1f786baffce17bb270e2991909cdc68444441757f94bd3f898b939bf1648'
AND (
token = 'qfidCLMaJY2mqpAtxhYV85YJPez69GEenFvf6gLuVvo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)