UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nE3yW/deuDc7wgsxaTVFHh+etIIE4tmo10MRISwMTIc='
WHERE
key_id = 'c94e552aee0cbd4764baa3b24819d139768615f28b7813ce53860a7ca776cdb3'
AND (
token = 'nE3yW/deuDc7wgsxaTVFHh+etIIE4tmo10MRISwMTIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)