UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ob9mBTCPvE7XFhV4hdZCQ7srcwNumaQ56iO+2VKhpI0='
WHERE
key_id = 'bbce50b7f7ec59d1a50882a181843ebf9ac7229b834f2236f74654562962ea16'
AND (
token = 'ob9mBTCPvE7XFhV4hdZCQ7srcwNumaQ56iO+2VKhpI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)