UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qxt0RqZZO2vpCz4FZFfLZ71MmF4bR+GXR92w01u4JgU='
WHERE
key_id = '8827325dd1315b81c75fdac37c4d7fe9b404dc0eac0045ddffb42e35785fde76'
AND (
token = 'qxt0RqZZO2vpCz4FZFfLZ71MmF4bR+GXR92w01u4JgU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)