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