UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4N5/D+YIZqkKAnW/B4VXI0Cmv0V/frYKLUVWMN34FCI='
WHERE
key_id = '9ad1ce2448b4b37cfea74e0b48b9748a1b69b3ffe874e7d4bf34726aae68ea6e'
AND (
token = '4N5/D+YIZqkKAnW/B4VXI0Cmv0V/frYKLUVWMN34FCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)