UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKlBqO2wNvrZ4bII60A2kAZN6p3G+4peQQc4zYyFRHg='
WHERE
key_id = '9a8b18e295c9204f3393fd7afb43ef5145f160c32e4e93a43dbadaee73a20913'
AND (
token = 'yKlBqO2wNvrZ4bII60A2kAZN6p3G+4peQQc4zYyFRHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)