UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7fjjGl9jip2cR1i11xzfMf0TmG9mAQwls5m+RWvtWOY='
WHERE
key_id = 'd8b25d7e4129b285c52082a3438e905d244c7ac6fa97389a3e78be3e8d1f6c9a'
AND (
token = '7fjjGl9jip2cR1i11xzfMf0TmG9mAQwls5m+RWvtWOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)