UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLruhK5TVOhu80jgx3iFNHzRm3yPALzsPREoe2mZdv8='
WHERE
key_id = '58b4e2bea9a2fe4990a7294aea5e44c24d134214caa4c242e882dec3976bc0ab'
AND (
token = 'XLruhK5TVOhu80jgx3iFNHzRm3yPALzsPREoe2mZdv8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)