UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wHoK2w7R6e/rd/zn3yqGDhqLmbdjkwTRvW1c3a2BbM='
WHERE
key_id = '7992765d1509b963deaa6a0ff68f0448c26c5c11cec123dab5bd6133e5ac4396'
AND (
token = '9wHoK2w7R6e/rd/zn3yqGDhqLmbdjkwTRvW1c3a2BbM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)