UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tsL9C6JmIsb6fE2SoWKhZX8fpCYHNUgm15IYn5t2alg='
WHERE
key_id = 'ba39d9f7b6f54de6a8254876cb0af787d4f808427811bd9771c69f709262b5cf'
AND (
token = 'tsL9C6JmIsb6fE2SoWKhZX8fpCYHNUgm15IYn5t2alg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)