UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jLNXF0EnchnD875uB0NUuj8p2ctsZ9U0J9YtMRuhjSk='
WHERE
key_id = '40781acff2360633807d8573693c56acd8fc793370af2400f13eac2bddfa6173'
AND (
token = 'jLNXF0EnchnD875uB0NUuj8p2ctsZ9U0J9YtMRuhjSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)