UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hq/2uCxGdCiWQ3hTOuBVgjgERR0sLYIB7fjyJDH17BU='
WHERE
key_id = 'ba304a9be29a276e091c69bede38a5e69266d888d66d99961451916fe5ecdfca'
AND (
token = 'hq/2uCxGdCiWQ3hTOuBVgjgERR0sLYIB7fjyJDH17BU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)