UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pc1W6CIG0M9TEOINTgAe2uhq7ohXDK8RaVTCFVcTuco='
WHERE
key_id = '1255b3884d082425d81c93ca9a3e0898385b8e2cb07b016f0db370de5a19b4d8'
AND (
token = 'pc1W6CIG0M9TEOINTgAe2uhq7ohXDK8RaVTCFVcTuco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)