UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/i0oQs7aKOGZk6Hkq8de3S7tD/mPTZRrpdYrXAOATjY='
WHERE
key_id = 'b1d184e66312229835b08a02d5e61cac71c407692f3262869e253549f9ff0510'
AND (
token = '/i0oQs7aKOGZk6Hkq8de3S7tD/mPTZRrpdYrXAOATjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)