UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UqNRCN2L/N7siS+pZyGFGYfE5+IAvSH7JxahC4oQGyw='
WHERE
key_id = 'bd8bcfb2cd1e1a2c3f2e652527e9d6544d43182aa5623abb09e155121289a9bd'
AND (
token = 'UqNRCN2L/N7siS+pZyGFGYfE5+IAvSH7JxahC4oQGyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)