UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ixEGj973So9YrrrSbfoTO6PTMWXOWVLCH+2OSDPeLZA='
WHERE
key_id = 'c9ee280f307d1523c42e2a4156db2ca2c4da153fad727a2251bc9fda43f0df1c'
AND (
token = 'ixEGj973So9YrrrSbfoTO6PTMWXOWVLCH+2OSDPeLZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)