UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PcnA2dr9bvfErtmO6ah+k/p4kLwIlx7rAO12Z5v9gk0='
WHERE
key_id = '8b0e195a9dd32abef3bf5486bfe3a773f9fd20e4c4865d39883cc49bd968dd9b'
AND (
token = 'PcnA2dr9bvfErtmO6ah+k/p4kLwIlx7rAO12Z5v9gk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)