UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1hqhcpGU8BEj5F0QSYripdnd5K99zszJV2B7xJov+yo='
WHERE
key_id = 'b2c11786002727963b57c9b3e9d1cf878f5662efbccdfb51fa4452ed0b8bfe92'
AND (
token = '1hqhcpGU8BEj5F0QSYripdnd5K99zszJV2B7xJov+yo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)