UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zB6CfosWgzgdg8K2USvuCb/lYcHfqrMz2I9DkNue51Q='
WHERE
key_id = '2b7b3c612df210901fb451c5bd81b980285204c7a3ed733797e0c8321150764c'
AND (
token = 'zB6CfosWgzgdg8K2USvuCb/lYcHfqrMz2I9DkNue51Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)