UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UukQLnQtZ0bQGAzv0YpcKQ9c7Wl9wNbqGWHEVM5NkgI='
WHERE
key_id = 'd9a6ea29431141998a91c323680b7cad8caf53b00f51f4e4e8f928c3c49147ac'
AND (
token = 'UukQLnQtZ0bQGAzv0YpcKQ9c7Wl9wNbqGWHEVM5NkgI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)