UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8iHmFZ0bsSKksBX0TLGNRmS+sdfj/bh2xv12MTr52E='
WHERE
key_id = '1f7cb2e0e02661e6ac6cf19a4bbb812562c449226a99cb358eb08289618d2143'
AND (
token = 'W8iHmFZ0bsSKksBX0TLGNRmS+sdfj/bh2xv12MTr52E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)