UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sU+PRTi/vJDWk7ABTW7mTK/l3bRTL1bY3wQF6Oj/36M='
WHERE
key_id = 'aa1be94cd18939122a309fd0daf79f3ae4545024992eb01cff2e5539ac763eea'
AND (
token = 'sU+PRTi/vJDWk7ABTW7mTK/l3bRTL1bY3wQF6Oj/36M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)